{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/ashutosh/Desktop/SenateDemocratCommitteeRequests.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 2 Jun 2025, 10:42:53

{com}. do "/Users/ashutosh/Desktop/Submissions/Matching Politicians/PSRM Replication Files/SenateDemocratCommitteeRequests.do"
{txt}
{com}. // This file replicates Figure 1 and Table A4
. 
. clear
{txt}
{com}. // Download the Democrat Committee Requests data
. use SenateDemocratCommitteeRequests.dta
{txt}
{com}. 
. 
. **************
. ** Figure 1 **
. **************
. 
. // Generate an indicator variable for being a Freshman
. gen Freshman = 1 if chambsen == 1
{txt}(263 missing values generated)

{com}. replace Freshman = 0 if chambsen != 1
{txt}(263 real changes made)

{com}. 
. // Counts number of Constituency Committees Requested in 1st Request
. // Note Constituency committees are 1) Small Business, 2) Veterans Affairs, 3) Agriculture, Nutrition and Forestry, 4) Armed Services, 5) Energy and Natural Resources
. 
. gen ConstituencyReq1 = 1 if commreq1 == "Small Business" | commreq1 == "Veterans Affairs" | commreq1 == "Agriculture, Nutrition and Forestry" | commreq1 == "Armed Services" | commreq1 == "Energy and Natural Resources"
{txt}(330 missing values generated)

{com}. 
. // Counts number of Policy Committees Requested in 1st Request
. // Note Policy committees are 1) Banking, Housing, and Urban Affairs, 2) Commerce, Science and Transportation, 3) Environment and Public Works, 4) Finance, 5) Foreign Relations, 6) Government Affairs, 7) Judiciary, 8) Labor and Human Resources
. 
. bysort Freshman: summarize ConstituencyReq1

{txt}{hline}
-> Freshman = 0

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
Constituen~1 {c |}{res}         38           1           0          1          1

{txt}{hline}
-> Freshman = 1

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
Constituen~1 {c |}{res}         25           1           0          1          1

{txt}
{com}. 
. gen PolicyReq1 = 1 if commreq1 == "Banking, Housing, and Urban Affairs" | commreq1 == "Commerce, Science and Transportation" | commreq1 == "Environment and Public Works" | commreq1 == "Finance" | commreq1 == "Foreign Relations" | commreq1 == "Government Affairs" | commreq1 == "Judiciary" | commreq1 == "Labor and Human Resources"
{txt}(196 missing values generated)

{com}. 
. bysort Freshman: summarize PolicyReq1

{txt}{hline}
-> Freshman = 0

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}PolicyReq1 {c |}{res}        128           1           0          1          1

{txt}{hline}
-> Freshman = 1

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}PolicyReq1 {c |}{res}         69           1           0          1          1

{txt}
{com}. 
. 
. // Counts number of Prestige Committees Requested in 1st Request
. // Note Constituency committees are 1) Appropriations, 2) Budget, 3) Rules and Administration
. 
. gen PrestigeReq1 = 1 if commreq1 == "Appropriations" | commreq1 == "Budget" | commreq1 == "Rules and Administration"
{txt}(266 missing values generated)

{com}. 
. bysort Freshman: summarize PrestigeReq1

{txt}{hline}
-> Freshman = 0

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
PrestigeReq1 {c |}{res}         91           1           0          1          1

{txt}{hline}
-> Freshman = 1

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
PrestigeReq1 {c |}{res}         36           1           0          1          1

{txt}
{com}. 
. 
. // Counts number of Admin Committees Requested in 1st Request
. // Note Constituency committees are 1) District of Columbia, 2) Post Office
. gen AdminReq1 = 1 if commreq1 == "District of Columbia" | commreq1 == "Post Office" 
{txt}(390 missing values generated)

{com}. 
. bysort Freshman: summarize AdminReq1

{txt}{hline}
-> Freshman = 0

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}AdminReq1 {c |}{res}          3           1           0          1          1

{txt}{hline}
-> Freshman = 1

    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}AdminReq1 {c |}{res}          0

{txt}
{com}. 
. 
. 
. // Now we can create a pie-chart for the category of committee requested as first choice by Freshman
. * Calculate sums for the subset where Freshman == 1
. summarize PrestigeReq1 if Freshman == 1

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
PrestigeReq1 {c |}{res}         36           1           0          1          1
{txt}
{com}. gen sum_prestige_f = r(sum)
{txt}
{com}. 
. summarize ConstituencyReq1 if Freshman == 1

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
Constituen~1 {c |}{res}         25           1           0          1          1
{txt}
{com}. gen sum_constituency_f = r(sum)
{txt}
{com}. 
. summarize AdminReq1 if Freshman == 1

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}AdminReq1 {c |}{res}          0
{txt}
{com}. gen sum_admin_f = r(sum)
{txt}
{com}. 
. summarize PolicyReq1 if Freshman == 1

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}PolicyReq1 {c |}{res}         69           1           0          1          1
{txt}
{com}. gen sum_policy_f = r(sum)
{txt}
{com}. 
. 
. graph pie sum_prestige_f sum_constituency_f sum_admin_f sum_policy_f
{res}{txt}
{com}. 
. * Save graph of Figure 1 for Freshmen
. graph save Figure1_Freshmen
{res}{txt}file {bf:Figure1_Freshmen.gph} saved

{com}. 
. 
. 
. scalar Freshman_Prestige_Req1 = sum_prestige_f /(sum_prestige_f + sum_constituency_f + sum_admin_f + sum_policy_f)
{txt}
{com}. display Freshman_Prestige_Req1
{res}.27692308
{txt}
{com}. 
. 
. scalar Freshman_Admin_Req1 = sum_admin_f /(sum_prestige_f + sum_constituency_f + sum_admin_f + sum_policy_f)
{txt}
{com}. display Freshman_Admin_Req1
{res}0
{txt}
{com}. 
. 
. scalar Freshman_Constituency_Req1 = sum_constituency_f /(sum_prestige_f + sum_constituency_f + sum_admin_f + sum_policy_f)
{txt}
{com}. display  Freshman_Constituency_Req1 
{res}.19230769
{txt}
{com}. 
. 
. scalar Freshman_Policy_Req1 = sum_policy_f /(sum_prestige_f + sum_constituency_f + sum_admin_f + sum_policy_f)
{txt}
{com}. display Freshman_Policy_Req1
{res}.53076923
{txt}
{com}. 
. 
. 
. // Now we can create a pie-chart for the category of committee requested as first choice by Non-Freshman
. * Calculate sums for the subset where Freshman == 0
. summarize PrestigeReq1 if Freshman == 0

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
PrestigeReq1 {c |}{res}         91           1           0          1          1
{txt}
{com}. gen sum_prestige_nf = r(sum)
{txt}
{com}. 
. summarize ConstituencyReq1 if Freshman == 0

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
Constituen~1 {c |}{res}         38           1           0          1          1
{txt}
{com}. gen sum_constituency_nf = r(sum)
{txt}
{com}. 
. summarize AdminReq1 if Freshman == 0

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}AdminReq1 {c |}{res}          3           1           0          1          1
{txt}
{com}. gen sum_admin_nf = r(sum)
{txt}
{com}. 
. summarize PolicyReq1 if Freshman == 0

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}PolicyReq1 {c |}{res}        128           1           0          1          1
{txt}
{com}. gen sum_policy_nf = r(sum)
{txt}
{com}. 
. 
. graph pie sum_prestige_nf sum_constituency_nf sum_admin_nf sum_policy_nf
{res}{txt}
{com}. 
. * Save graph of Figure 1 for Non-Freshmen
. graph save Figure1_NonFreshmen
{res}{txt}file {bf:Figure1_NonFreshmen.gph} saved

{com}. 
. scalar NonFreshman_Prestige_Req1 = sum_prestige_nf /(sum_prestige_nf + sum_constituency_nf + sum_admin_nf + sum_policy_nf)
{txt}
{com}. display NonFreshman_Prestige_Req1
{res}.35
{txt}
{com}. 
. 
. scalar NonFreshman_Admin_Req1 = sum_admin_nf /(sum_prestige_nf + sum_constituency_nf + sum_admin_nf + sum_policy_nf)
{txt}
{com}. display NonFreshman_Admin_Req1
{res}.01153846
{txt}
{com}. 
. 
. scalar NonFreshman_Constituency_Req1 = sum_constituency_nf /(sum_prestige_nf + sum_constituency_nf + sum_admin_nf + sum_policy_nf)
{txt}
{com}. display  NonFreshman_Constituency_Req1 
{res}.14615385
{txt}
{com}. 
. 
. scalar NonFreshman_Policy_Req1 = sum_policy_nf /(sum_prestige_nf + sum_constituency_nf + sum_admin_nf + sum_policy_nf)
{txt}
{com}. display NonFreshman_Policy_Req1
{res}.49230769
{txt}
{com}. 
. **************
. ** Table A4 **
. **************
. 
. ** Constituency Committees
. summarize chambsen if  ifrequestedsmallbuss ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         34    3.205882     2.69432          1         11
{txt}
{com}. scalar avg_sen_smallbusiness = r(mean)
{txt}
{com}. display avg_sen_smallbusiness
{res}3.2058824
{txt}
{com}. 
. summarize chambsen if  ifrequstedveter ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}          6         1.5      .83666          1          3
{txt}
{com}. scalar avg_sen_veteransaffair = r(mean)
{txt}
{com}. display avg_sen_veteransaffair
{res}1.5
{txt}
{com}. 
. summarize chambsen if  ifrequestedagri ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         36    2.055556    2.353653          1         11
{txt}
{com}. scalar avg_sen_agriculture = r(mean)
{txt}
{com}. display avg_sen_agriculture
{res}2.0555556
{txt}
{com}. 
. summarize chambsen if  ifreqarmed ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         68    3.779412    5.536435          1         31
{txt}
{com}. scalar avg_sen_armedserv = r(mean)
{txt}
{com}. display avg_sen_armedserv
{res}3.7794118
{txt}
{com}. 
. summarize chambsen if  ifreqenergy ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         48    2.354167    3.316558          1         20
{txt}
{com}. scalar avg_sen_energy = r(mean)
{txt}
{com}. display avg_sen_energy
{res}2.3541667
{txt}
{com}. 
. 
. scalar avg_constituency = (avg_sen_energy + avg_sen_armedserv + avg_sen_agriculture + avg_sen_veteransaffair + avg_sen_smallbusiness)/5
{txt}
{com}. display avg_constituency
{res}2.5790033
{txt}
{com}. 
. 
. ** Policy Committees
. summarize chambsen if  ifreqbanking ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         42    2.047619    3.950624          1         26
{txt}
{com}. scalar avg_sen_banking = r(mean)
{txt}
{com}. display avg_sen_banking
{res}2.047619
{txt}
{com}. 
. summarize chambsen if  ifreqcommerce ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         99    2.676768    3.867257          1         26
{txt}
{com}. scalar avg_sen_commerce = r(mean)
{txt}
{com}. display avg_sen_commerce
{res}2.6767677
{txt}
{com}. 
. summarize chambsen if  ifreqenviron ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         60    2.083333    2.338272          1         13
{txt}
{com}. scalar avg_sen_environment = r(mean)
{txt}
{com}. display avg_sen_environment
{res}2.0833333
{txt}
{com}. 
. summarize chambsen if  ifreqfinan ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         80        3.25    3.675096          1         22
{txt}
{com}. scalar avg_sen_finance = r(mean)
{txt}
{com}. display avg_sen_finance
{res}3.25
{txt}
{com}. 
. summarize chambsen if  ifreqforaff ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}        110    5.290909     5.46271          1         24
{txt}
{com}. scalar avg_sen_foreignaffairs = r(mean)
{txt}
{com}. display avg_sen_foreignaffairs
{res}5.2909091
{txt}
{com}. 
. summarize chambsen if  ifreqgovtaff ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         26    2.346154    3.509328          1         16
{txt}
{com}. scalar avg_sen_govtaffairs = r(mean)
{txt}
{com}. display avg_sen_govtaffairs
{res}2.3461538
{txt}
{com}. 
. summarize chambsen if  ifreqjudi ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         56    3.142857    3.777583          1         20
{txt}
{com}. scalar avg_sen_judiciary = r(mean)
{txt}
{com}. display avg_sen_judiciary
{res}3.1428571
{txt}
{com}. 
. summarize chambsen if  ifreqlabor ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         43    2.255814    3.162978          1         17
{txt}
{com}. scalar avg_sen_labor = r(mean)
{txt}
{com}. display avg_sen_labor
{res}2.255814
{txt}
{com}. 
. 
. scalar avg_policy = (avg_sen_banking + avg_sen_commerce + avg_sen_environment + avg_sen_finance + avg_sen_foreignaffairs + avg_sen_govtaffairs + avg_sen_judiciary + avg_sen_labor)/8
{txt}
{com}. display avg_policy
{res}2.8866818
{txt}
{com}. 
. 
. ** Prestige Committees
. 
. summarize chambsen if  ifreqappro ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}        138    4.297101    4.306521          1         26
{txt}
{com}. scalar avg_sen_appropriations = r(mean)
{txt}
{com}. display avg_sen_appropriations
{res}4.2971014
{txt}
{com}. 
. summarize chambsen if  ifreqbudget ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         16      4.3125    6.915863          1         29
{txt}
{com}. scalar avg_sen_budget= r(mean)
{txt}
{com}. display avg_sen_budget
{res}4.3125
{txt}
{com}. 
. summarize chambsen if  ifreqrules ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}         24    3.041667    2.422345          1          8
{txt}
{com}. scalar avg_sen_rules = r(mean)
{txt}
{com}. display avg_sen_rules
{res}3.0416667
{txt}
{com}. 
. 
. scalar avg_prestige = (avg_sen_appropriations + avg_sen_budget + avg_sen_rules)/3
{txt}
{com}. display avg_prestige
{res}3.883756
{txt}
{com}. 
. 
. 
. ** Admin Committees
. 
. summarize chambsen if  ifreqdistric ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}          3    2.333333    2.309401          1          5
{txt}
{com}. scalar avg_sen_districtofcolumbia = r(mean)
{txt}
{com}. display avg_sen_districtofcolumbia
{res}2.3333333
{txt}
{com}. 
. summarize chambsen if  ifreqpost ==1 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}chambsen {c |}{res}          8         3.5    3.817254          1         11
{txt}
{com}. scalar avg_sen_post= r(mean)
{txt}
{com}. display avg_sen_post
{res}3.5
{txt}
{com}. 
. 
. scalar avg_admin = (avg_sen_districtofcolumbia+avg_sen_post)/2
{txt}
{com}. display avg_admin
{res}2.9166667
{txt}
{com}. 
. 
. matrix TableA4 =avg_sen_smallbusiness\avg_sen_veteransaffair\avg_sen_agriculture\avg_sen_armedserv\avg_sen_energy\avg_constituency\avg_sen_banking\avg_sen_commerce\avg_sen_environment\avg_sen_finance\avg_sen_foreignaffairs\avg_sen_govtaffairs\avg_sen_judiciary\avg_sen_labor\avg_policy\avg_sen_appropriations\avg_sen_budget\avg_sen_rules\avg_prestige\avg_sen_districtofcolumbia \avg_sen_post \avg_admin
{txt}
{com}. 
. esttab matrix(TableA4) using TableA4
{res}{txt}(output written to {browse  `"TableA4.txt"'})

{com}. 
.           
. 
{txt}end of do-file

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/ashutosh/Desktop/SenateDemocratCommitteeRequests.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 2 Jun 2025, 10:43:09
{txt}{.-}
{smcl}
{txt}{sf}{ul off}